package com.panasonic.cn.cmsc;

import java.io.*;
import java.lang.*;
import java.util.*;
import java.math.*;
import java.sql.SQLException;
import com.fujitsu.fks.jaaf.core.*;

public class SQLMM0201{
	private Hashtable paramsString     = new Hashtable();
	private Hashtable paramsBigDecimal = new Hashtable();
	private Hashtable paramsFree       = new Hashtable();
	private String lastSql_ = null;

	private String getString(String name){
		if(name==null) return "";
		String returnStr = (String)paramsString.get(name);
		if(returnStr==null) return "";
		return "'"+FrameworkCommon.stringReplaceSQuote(returnStr)+"'";
	}

	private String getBigDecimal(String name){
		if(name==null) return "";
		BigDecimal returnStr = (BigDecimal)paramsBigDecimal.get(name);
		if(returnStr==null) return "";
		return returnStr.toString();
	}

	private String getFree(String name){
		if(name==null) return "";
		String returnStr = (String)paramsFree.get(name);
		if(returnStr==null) return "";
		return returnStr;
	}

	public String getLastSql(){
		return lastSql_;
	}

	public int INSERT_M0201(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("INSERT INTO ");
		sql.append("M02(");
		sql.append("ITM_NO,");
		sql.append("ODR_DVSN_CD,");
		sql.append("APL_BDT,");
		sql.append("APL_EDT,");
		sql.append("GNR_ADM_NO,");
		sql.append("TMP_AC_TYP,");
		sql.append("SCSN_ITM_NO,");
		sql.append("QTY_NSUM_TYP,");
		sql.append("CSLD_ITM_NO,");
		sql.append("CTRL_DVSN_CD,");
		sql.append("MFCC_CD,");
		sql.append("PRNT_DVSN_CD,");
		sql.append("DSP_SPCF_CTNT,");
		sql.append("IBO_CAT_CD,");
		sql.append("FMCC_DPT_NM,");
		sql.append("FMCC_CHRG_NM,");
		sql.append("PRV_ITM_NO,");
		sql.append("CLR_CD,");
		sql.append("BRND_CD,");
		sql.append("HS_CD,");
		sql.append("ACC_CAT_CD,");
		sql.append("ITM_NM_ENG,");
		sql.append("SLS_QTY_UN_CD,");
		sql.append("SLC_PRMT_ITM_TYP,");
		sql.append("KIT_TYP,");
		sql.append("GFT_TYP,");
		sql.append("FOC_TYP,");
		sql.append("MIN_ODR_QTY,");
		sql.append("STD_PKG_SZ,");
		sql.append("STD_PKG_WDTH,");
		sql.append("STD_PKG_HI,");
		sql.append("STD_PKG_WGT,");
		sql.append("TMP_PRIZ_TYP,");
		sql.append("STD_UP,");
		sql.append("ITM_NM_CN,");
		sql.append("SLS_ROUT_TYP,");
		sql.append("ITM_NET_WGT,");
		sql.append("RGS_DTTM,");
		sql.append("RGS_CHRG_CD,");
		sql.append("RGS_PGID,");
		sql.append("UPD_DTTM,");
		sql.append("UPD_CHRG_CD,");
		sql.append("UPD_PGID,");
		sql.append("FM_TYP");
		sql.append(")");
		sql.append("VALUES");
		sql.append("(");
		sql.append(""+getString("ITM_NO")+",");
		sql.append(""+getString("ODR_DVSN_CD")+",");
		sql.append(""+getString("APL_BDT")+",");
		sql.append(""+getString("APL_EDT")+",");
		sql.append(""+getString("GNR_ADM_NO")+",");
		sql.append(""+getString("TMP_AC_TYP")+",");
		sql.append(""+getString("SCSN_ITM_NO")+",");
		sql.append(""+getString("QTY_NSUM_TYP")+",");
		sql.append(""+getString("CSLD_ITM_NO")+",");
		sql.append(""+getString("CTRL_DVSN_CD")+",");
		sql.append(""+getString("MFCC_CD")+",");
		sql.append(""+getString("PRNT_DVSN_CD")+",");
		sql.append(""+getString("DSP_SPCF_CTNT")+",");
		sql.append(""+getString("IBO_CAT_CD")+",");
		sql.append(""+getString("FMCC_DPT_NM")+",");
		sql.append(""+getString("FMCC_CHRG_NM")+",");
		sql.append(""+getString("PRV_ITM_NO")+",");
		sql.append(""+getString("CLR_CD")+",");
		sql.append(""+getString("BRND_CD")+",");
		sql.append(""+getString("HS_CD")+",");
		sql.append(""+getString("ACC_CAT_CD")+",");
		sql.append(""+getString("ITM_NM_ENG")+",");
		sql.append(""+getString("SLS_QTY_UN_CD")+",");
		sql.append(""+getString("SLC_PRMT_ITM_TYP")+",");
		sql.append(""+getString("KIT_TYP")+",");
		sql.append(""+getString("GFT_TYP")+",");
		sql.append(""+getString("FOC_TYP")+",");
		sql.append(""+getString("MIN_ODR_QTY")+",");
		sql.append(""+getString("STD_PKG_SZ")+",");
		sql.append(""+getString("STD_PKG_WDTH")+",");
		sql.append(""+getString("STD_PKG_HI")+",");
		sql.append(""+getString("STD_PKG_WGT")+",");
		sql.append(""+getString("TMP_PRIZ_TYP")+",");
		sql.append(""+getString("STD_UP")+",");
		sql.append(""+getString("ITM_NM_CN")+",");
		sql.append(""+getString("SLS_ROUT_TYP")+",");
		sql.append(""+getString("ITM_NET_WGT")+",");
		sql.append("TO_DATE("+getString("RGS_DTTM")+",'YYYYMMDD HH24:MI:SS'),");
		sql.append(""+getString("RGS_CHRG_CD")+",");
		sql.append(""+getString("RGS_PGID")+",");
		sql.append("TO_DATE("+getString("UPD_DTTM")+",'YYYYMMDD HH24:MI:SS'),");
		sql.append(""+getString("UPD_CHRG_CD")+",");
		sql.append(""+getString("UPD_PGID")+",");
		sql.append(""+getString("FM_TYP")+"");
		sql.append(")");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		int updateCount = db.executeUpdate();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return updateCount;
	}

	public SelectResultRset SELECT_M0201(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("SELECT ");
		sql.append("NVL( ITM_NO,          '') AS ITM_NO, ");
		sql.append("NVL( ODR_DVSN_CD,     '') AS ODR_DVSN_CD, ");
		sql.append("NVL( APL_BDT,         '') AS APL_BDT, ");
		sql.append("NVL( APL_EDT,         '') AS APL_EDT, ");
		sql.append("NVL( GNR_ADM_NO,      '') AS GNR_ADM_NO, ");
		sql.append("NVL( TMP_AC_TYP,      '') AS TMP_AC_TYP, ");
		sql.append("NVL( SCSN_ITM_NO,     '') AS SCSN_ITM_NO, ");
		sql.append("NVL( QTY_NSUM_TYP,    '') AS QTY_NSUM_TYP, ");
		sql.append("NVL( CSLD_ITM_NO,     '') AS CSLD_ITM_NO, ");
		sql.append("NVL( CTRL_DVSN_CD,    '') AS CTRL_DVSN_CD, ");
		sql.append("NVL( MFCC_CD,         '') AS MFCC_CD, ");
		sql.append("NVL( PRNT_DVSN_CD,    '') AS PRNT_DVSN_CD, ");
		sql.append("NVL( DSP_SPCF_CTNT,   '') AS DSP_SPCF_CTNT, ");
		sql.append("NVL( IBO_CAT_CD,      '') AS IBO_CAT_CD, ");
		sql.append("NVL( FMCC_DPT_NM,     '') AS FMCC_DPT_NM, ");
		sql.append("NVL( FMCC_CHRG_NM,    '') AS FMCC_CHRG_NM, ");
		sql.append("NVL( PRV_ITM_NO,      '') AS PRV_ITM_NO, ");
		sql.append("NVL( CLR_CD,          '') AS CLR_CD, ");
		sql.append("NVL( BRND_CD,         '') AS BRND_CD, ");
		sql.append("NVL( HS_CD,           '') AS HS_CD, ");
		sql.append("NVL( ACC_CAT_CD,      '') AS ACC_CAT_CD, ");
		sql.append("NVL( ITM_NM_ENG,      '') AS ITM_NM_ENG, ");
		sql.append("NVL( SLS_QTY_UN_CD,   '') AS SLS_QTY_UN_CD, ");
		sql.append("NVL( SLC_PRMT_ITM_TYP,'') AS SLC_PRMT_ITM_TYP, ");
		sql.append("NVL( KIT_TYP,         '') AS KIT_TYP, ");
		sql.append("NVL( GFT_TYP,         '') AS GFT_TYP, ");
		sql.append("NVL( FOC_TYP,         '') AS FOC_TYP, ");
		sql.append("NVL( MIN_ODR_QTY,     '') AS MIN_ODR_QTY, ");
		sql.append("NVL( STD_PKG_SZ,      '') AS STD_PKG_SZ, ");
		sql.append("NVL( STD_PKG_WDTH,    '') AS STD_PKG_WDTH, ");
		sql.append("NVL( STD_PKG_HI,      '') AS STD_PKG_HI, ");
		sql.append("NVL( STD_PKG_WGT,     '') AS STD_PKG_WGT, ");
		sql.append("NVL( TMP_PRIZ_TYP,    '') AS TMP_PRIZ_TYP, ");
		sql.append("NVL( STD_UP,          '') AS STD_UP, ");
		sql.append("NVL( ITM_NM_CN,       '') AS ITM_NM_CN, ");
		sql.append("NVL( SLS_ROUT_TYP,    '') AS SLS_ROUT_TYP,");
		sql.append("NVL( ITM_NET_WGT,     '') AS ITM_NET_WGT,");
		sql.append("NVL( FM_TYP,          '') AS FM_TYP, ");
		sql.append("TO_CHAR(UPD_DTTM,'yyyyMMdd HH24:MI:SS') AS UPD_DTTM ");
		sql.append("FROM M02 ");
		sql.append("WHERE ");
		sql.append("ITM_NO "+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+" ");
		sql.append("AND ");
		sql.append("ODR_DVSN_CD "+((getString("ODR_DVSN_CD").equals(""))?" is null ":"=")+getString("ODR_DVSN_CD")+" ");
		sql.append("AND ");
		sql.append("APL_BDT"+((getString("APL_BDT").equals(""))?" is null ":"=")+getString("APL_BDT")+" ");
		sql.append("ORDER BY ");
		sql.append("ITM_NO,ODR_DVSN_CD,APL_BDT");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		SelectResultRset srr = db.executeQuery();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return srr;
	}

	public SelectResultRset SELECT_M0202(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("SELECT ");
		sql.append("NVL( ITM_NO,          '') AS ITM_NO, ");
		sql.append("NVL( ODR_DVSN_CD,     '') AS ODR_DVSN_CD, ");
		sql.append("NVL( APL_BDT,         '') AS APL_BDT, ");
		sql.append("NVL( APL_EDT,         '') AS APL_EDT, ");
		sql.append("NVL( GNR_ADM_NO,      '') AS GNR_ADM_NO, ");
		sql.append("NVL( TMP_AC_TYP,      '') AS TMP_AC_TYP, ");
		sql.append("NVL( SCSN_ITM_NO,     '') AS SCSN_ITM_NO, ");
		sql.append("NVL( QTY_NSUM_TYP,    '') AS QTY_NSUM_TYP, ");
		sql.append("NVL( CSLD_ITM_NO,     '') AS CSLD_ITM_NO, ");
		sql.append("NVL( CTRL_DVSN_CD,    '') AS CTRL_DVSN_CD, ");
		sql.append("NVL( MFCC_CD,         '') AS MFCC_CD, ");
		sql.append("NVL( PRNT_DVSN_CD,    '') AS PRNT_DVSN_CD, ");
		sql.append("NVL( DSP_SPCF_CTNT,   '') AS DSP_SPCF_CTNT, ");
		sql.append("NVL( IBO_CAT_CD,      '') AS IBO_CAT_CD, ");
		sql.append("NVL( FMCC_DPT_NM,     '') AS FMCC_DPT_NM, ");
		sql.append("NVL( FMCC_CHRG_NM,    '') AS FMCC_CHRG_NM, ");
		sql.append("NVL( PRV_ITM_NO,      '') AS PRV_ITM_NO, ");
		sql.append("NVL( CLR_CD,          '') AS CLR_CD, ");
		sql.append("NVL( BRND_CD,         '') AS BRND_CD, ");
		sql.append("NVL( HS_CD,           '') AS HS_CD, ");
		sql.append("NVL( ACC_CAT_CD,      '') AS ACC_CAT_CD, ");
		sql.append("NVL( ITM_NM_ENG,      '') AS ITM_NM_ENG, ");
		sql.append("NVL( SLS_QTY_UN_CD,   '') AS SLS_QTY_UN_CD, ");
		sql.append("NVL( SLC_PRMT_ITM_TYP,'') AS SLC_PRMT_ITM_TYP, ");
		sql.append("NVL( KIT_TYP,         '') AS KIT_TYP, ");
		sql.append("NVL( GFT_TYP,         '') AS GFT_TYP, ");
		sql.append("NVL( FOC_TYP,         '') AS FOC_TYP, ");
		sql.append("NVL( MIN_ODR_QTY,     '') AS MIN_ODR_QTY, ");
		sql.append("NVL( STD_PKG_SZ,      '') AS STD_PKG_SZ, ");
		sql.append("NVL( STD_PKG_WDTH,    '') AS STD_PKG_WDTH, ");
		sql.append("NVL( STD_PKG_HI,      '') AS STD_PKG_HI, ");
		sql.append("NVL( STD_PKG_WGT,     '') AS STD_PKG_WGT, ");
		sql.append("NVL( TMP_PRIZ_TYP,    '') AS TMP_PRIZ_TYP, ");
		sql.append("NVL( STD_UP,          '') AS STD_UP, ");
		sql.append("NVL( ITM_NM_CN,       '') AS ITM_NM_CN, ");
		sql.append("NVL( SLS_ROUT_TYP,    '') AS SLS_ROUT_TYP,");
		sql.append("NVL( ITM_NET_WGT,     '') AS ITM_NET_WGT,");
		sql.append("NVL( FM_TYP,          '') AS FM_TYP, ");
		sql.append("TO_CHAR(UPD_DTTM,'yyyyMMdd HH24:MI:SS') AS UPD_DTTM ");
		sql.append("FROM M02 ");
		sql.append("WHERE ");
		sql.append("ITM_NO "+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+" ");
		sql.append("AND ");
		sql.append("ODR_DVSN_CD "+((getString("ODR_DVSN_CD").equals(""))?" is null ":"=")+getString("ODR_DVSN_CD")+" ");
		sql.append("AND ");
		sql.append("FM_TYP	"+((getString("FM_TYP").equals(""))?" is null ":"=")+getString("FM_TYP")+" ");
		sql.append("ORDER BY ");
		sql.append("ITM_NO,ODR_DVSN_CD ");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		SelectResultRset srr = db.executeQuery();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return srr;
	}

	public SelectResultRset SELECT_M0203(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("SELECT ");
		sql.append("NVL(ITM_NO, '') AS               ITM_NO,          ");
		sql.append("NVL(ODR_DVSN_CD, '') AS          ODR_DVSN_CD,     ");
		sql.append("NVL(APL_BDT, '') AS              APL_BDT,         ");
		sql.append("NVL(APL_EDT, '') AS              APL_EDT,         ");
		sql.append("NVL(GNR_ADM_NO, '') AS           GNR_ADM_NO,      ");
		sql.append("NVL(TMP_AC_TYP, '') AS           TMP_AC_TYP,      ");
		sql.append("NVL(SCSN_ITM_NO, '') AS          SCSN_ITM_NO,     ");
		sql.append("NVL(QTY_NSUM_TYP, '') AS         QTY_NSUM_TYP,    ");
		sql.append("NVL(CSLD_ITM_NO, '') AS          CSLD_ITM_NO,     ");
		sql.append("NVL(CTRL_DVSN_CD, '') AS         CTRL_DVSN_CD,    ");
		sql.append("NVL(MFCC_CD, '') AS              MFCC_CD,         ");
		sql.append("NVL(PRNT_DVSN_CD, '') AS         PRNT_DVSN_CD,    ");
		sql.append("NVL(DSP_SPCF_CTNT, '') AS        DSP_SPCF_CTNT,   ");
		sql.append("NVL(IBO_CAT_CD, '') AS           IBO_CAT_CD,      ");
		sql.append("NVL(FMCC_DPT_NM, '') AS          FMCC_DPT_NM,     ");
		sql.append("NVL(FMCC_CHRG_NM, '') AS         FMCC_CHRG_NM,    ");
		sql.append("NVL(PRV_ITM_NO, '') AS           PRV_ITM_NO,      ");
		sql.append("NVL(CLR_CD, '') AS               CLR_CD,          ");
		sql.append("NVL(BRND_CD, '') AS              BRND_CD,         ");
		sql.append("NVL(HS_CD, '') AS                HS_CD,           ");
		sql.append("NVL(ACC_CAT_CD, '') AS           ACC_CAT_CD,      ");
		sql.append("NVL(ITM_NM_ENG, '') AS           ITM_NM_ENG,      ");
		sql.append("NVL(SLS_QTY_UN_CD, '') AS        SLS_QTY_UN_CD,                     ");
		sql.append("NVL(SLC_PRMT_ITM_TYP, '') AS     SLC_PRMT_ITM_TYP,");
		sql.append("NVL(KIT_TYP, '') AS              KIT_TYP,         ");
		sql.append("NVL(GFT_TYP, '') AS              GFT_TYP,         ");
		sql.append("NVL(FOC_TYP, '') AS              FOC_TYP,         ");
		sql.append("NVL(MIN_ODR_QTY, '') AS          MIN_ODR_QTY,     ");
		sql.append("NVL(STD_PKG_SZ, '') AS           STD_PKG_SZ,      ");
		sql.append("NVL(STD_PKG_WDTH, '') AS         STD_PKG_WDTH,    ");
		sql.append("NVL(STD_PKG_HI, '') AS           STD_PKG_HI,      ");
		sql.append("NVL(STD_PKG_WGT, '') AS          STD_PKG_WGT,     ");
		sql.append("NVL(TMP_PRIZ_TYP, '') AS         TMP_PRIZ_TYP,    ");
		sql.append("NVL(STD_UP, '') AS               STD_UP,          ");
		sql.append("NVL(ITM_NM_CN, '') AS            ITM_NM_CN,       ");
		sql.append("NVL(SLS_ROUT_TYP, '') AS         SLS_ROUT_TYP, ");
		sql.append("NVL(ITM_NET_WGT, '')  AS         ITM_NET_WGT,  ");
		sql.append("NVL(RGS_DTTM, '') AS             RGS_DTTM,        ");
		sql.append("NVL(RGS_CHRG_CD, '') AS          RGS_CHRG_CD,     ");
		sql.append("NVL(RGS_PGID, '') AS             RGS_PGID,        ");
		sql.append("NVL(UPD_DTTM, '') AS             UPD_DTTM,        ");
		sql.append("NVL(UPD_CHRG_CD, '') AS          UPD_CHRG_CD,     ");
		sql.append("NVL(UPD_PGID, '') AS             UPD_PGID,        ");
		sql.append("NVL(FM_TYP, '') AS               FM_TYP    ");
		sql.append("FROM ");
		sql.append("M02 ");
		sql.append("WHERE ");
		sql.append("ITM_NO "+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+" ");
		sql.append("AND ");
		sql.append("ODR_DVSN_CD "+((getString("ODR_DVSN_CD").equals(""))?" is null ":"=")+getString("ODR_DVSN_CD")+" ");
		sql.append("AND ");
		sql.append("APL_BDT<=	"+getString("APL_BDT")+" ");
		sql.append("AND ");
		sql.append("APL_EDT>=	"+getString("APL_BDT")+" ");
		sql.append("ORDER BY ITM_NO,ODR_DVSN_CD,APL_BDT");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		SelectResultRset srr = db.executeQuery();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return srr;
	}

	public int DELETE_M0201(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("DELETE ");
		sql.append("FROM ");
		sql.append("M02 ");
		sql.append("WHERE ");
		sql.append("ITM_NO		"+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+" ");
		sql.append("AND ");
		sql.append("ODR_DVSN_CD	"+((getString("ODR_DVSN_CD").equals(""))?" is null ":"=")+getString("ODR_DVSN_CD")+" ");
		sql.append("AND ");
		sql.append("FM_TYP		"+((getString("FM_TYP").equals(""))?" is null ":"=")+getString("FM_TYP")+"");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		int updateCount = db.executeUpdate();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return updateCount;
	}

	public SelectResultRset SELECT_M0109(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("SELECT ");
		sql.append("NVL(TRPT_CLSS_D_TYP,'') AS TRPT_CLSS_D_TYP,");
		sql.append("NVL(CTRL_DVSN_CD,'')	AS CTRL_DVSN_CD ");
		sql.append("FROM ");
		sql.append("M01 ");
		sql.append("WHERE ");
		sql.append("VDR_CD "+((getString("VDR_CD").equals(""))?" is null ":"=")+getString("VDR_CD")+" ");
		sql.append("AND  ");
		sql.append("FM_TYP <> "+getString("FM_TYP1")+" ");
		sql.append("AND ");
		sql.append("FM_TYP <> "+getString("FM_TYP2")+" ");
		sql.append("AND ");
		sql.append("APL_BDT <"+((getString("APL_BDT").equals(""))?" is null ":"=")+getString("APL_BDT")+"");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		SelectResultRset srr = db.executeQuery();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return srr;
	}

	public SelectResultRset SELECT_MDLNO01(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("SELECT ");
		sql.append("NVL(A.UNI_ITM_NO ,    '') AS UNI_ITM_NO ,");
		sql.append("NVL(A.U_I_NO_DSTC_CD ,'') AS U_I_NO_DSTC_CD ,");
		sql.append("NVL(A.APL_BDT ,       '') AS APL_BDT ,");
		sql.append("NVL(A.DCAT_CD ,       '') AS DCAT_CD ,");
		sql.append("NVL(A.TMP_AC_TYP ,    '') AS TMP_AC_TYP ,");
		sql.append("NVL(A.AC_END_DT ,     '') AS AC_END_DT ,");
		sql.append("NVL(A.A_NOIG_DVSN_CD ,'') AS A_NOIG_DVSN_CD ,");
		sql.append("NVL(A.M_PRNT_DVSN_CD ,'') AS M_PRNT_DVSN_CD ,");
		sql.append("NVL(A.JPN_SLS_TYP ,   '') AS JPN_SLS_TYP ,");
		sql.append("NVL(A.EUR_SLS_TYP ,   '') AS EUR_SLS_TYP ,");
		sql.append("NVL(A.ASA_SLS_TYP ,   '') AS ASA_SLS_TYP ,");
		sql.append("NVL(A.AMRS_SLS_TYP ,  '') AS AMRS_SLS_TYP ,");
		sql.append("NVL(A.JPN_MFC_TYP ,   '') AS JPN_MFC_TYP ,");
		sql.append("NVL(A.EUR_MFC_TYP ,   '') AS EUR_MFC_TYP ,");
		sql.append("NVL(A.ASA_MFC_TYP ,   '') AS ASA_MFC_TYP ,");
		sql.append("NVL(A.AMRS_MFC_TYP ,  '') AS AMRS_MFC_TYP ,");
		sql.append("NVL(A.FGD_TYP ,       '') AS FGD_TYP ,");
		sql.append("NVL(A.PSRC_TYP ,      '') AS PSRC_TYP ,");
		sql.append("NVL(A.SMDL_TYP ,      '') AS SMDL_TYP ,");
		sql.append("NVL(A.ITM_NO_PTC_TYP ,'') AS ITM_NO_PTC_TYP ,");
		sql.append("NVL(A.ST_TYP_TYP ,    '') AS ST_TYP_TYP , ");
		sql.append("NVL(A.DMY_TYP_TYP ,   '') AS DMY_TYP_TYP ,");
		sql.append("NVL(A.M_PT_SYBL_TYP , '') AS M_PT_SYBL_TYP ,");
		sql.append("NVL(A.PT_TYP ,        '') AS PT_TYP ,");
		sql.append("NVL(A.PRD_BDT ,       '') AS PRD_BDT ,");
		sql.append("NVL(A.PRD_EDT ,       '') AS PRD_EDT ,");
		sql.append("NVL(A.PLRL_SLS_TYP ,  '') AS PLRL_SLS_TYP ,");
		sql.append("NVL(A.SLS_DVSN_CD ,   '') AS SLS_DVSN_CD ,");
		sql.append("NVL(A.I_N_R_PRMS_TYP ,'') AS I_N_R_PRMS_TYP ,");
		sql.append("NVL(A.ITM_NM1 ,       '') AS ITM_NM1 ,");
		sql.append("NVL(A.ITM_NM2 ,       '') AS ITM_NM2 ,");
		sql.append("NVL(A.MCD_PT_SYBL_CD ,'') AS MCD_PT_SYBL_CD ,");
		sql.append("NVL(A.JPN_POS_TYP ,   '') AS JPN_POS_TYP , ");
		sql.append("NVL(A.JPN_POS_CD ,    '') AS JPN_POS_CD ,");
		sql.append("NVL(A.EUR_POS_TYP ,   '') AS EUR_POS_TYP ,");
		sql.append("NVL(A.EUR_POS_CD ,    '') AS EUR_POS_CD ,");
		sql.append("NVL(A.ASA_POS_TYP ,   '') AS ASA_POS_TYP ,");
		sql.append("NVL(A.ASA_POS_CD ,    '') AS ASA_POS_CD ,");
		sql.append("NVL(A.LTAM_POS_TYP ,  '') AS LTAM_POS_TYP ,");
		sql.append("NVL(A.LTAM_POS_CD ,   '') AS LTAM_POS_CD ,");
		sql.append("NVL(A.NAMR_POS_TYP ,  '') AS NAMR_POS_TYP ,");
		sql.append("NVL(A.NAMR_POS_CD ,   '') AS NAMR_POS_CD ,");
		sql.append("NVL(A.E_RGN_POS_TYP , '') AS E_RGN_POS_TYP ,");
		sql.append("NVL(A.ETC_RGN_POS_CD ,'') AS ETC_RGN_POS_CD ,");
		sql.append("NVL(A.O_CPRS_ITM_NO , '') AS O_CPRS_ITM_NO ,");
		sql.append("NVL(A.O_CPRS_ITM_CD , '') AS O_CPRS_ITM_CD ,");
		sql.append("NVL(A.DEL_TYP ,       '') AS DEL_TYP ,");
		sql.append("NVL(A.RGS_PGM_NM ,    '') AS RGS_PGM_NM ,");
		sql.append("NVL(A.RGS_USR_ID ,    '') AS RGS_USR_ID ,");
		sql.append("NVL(A.RGS_DTTM ,      '') AS RGS_DTTM ,");
		sql.append("NVL(A.CHG_PGM_NM ,    '') AS CHG_PGM_NM ,");
		sql.append("NVL(A.CHG_USR_ID ,    '') AS CHG_USR_ID ,");
		sql.append("NVL(A.CHG_DTTM ,      '') AS CHG_DTTM ,");
		sql.append("NVL(A.CHG_TMS ,       '') AS CHG_TMS ,");
		sql.append("NVL(B.GCAT_CD ,       '') AS GCAT_CD ");
		sql.append("FROM MDLNO A, DCAT B ");
		sql.append("WHERE ");
		sql.append("A.DCAT_CD = B.DCAT_CD(+) ");
		sql.append("AND ");
		sql.append("A.UNI_ITM_NO "+((getString("UNI_ITM_NO").equals(""))?" is null ":"=")+getString("UNI_ITM_NO")+" ");
		sql.append("AND ");
		sql.append("A.APL_BDT <"+((getString("nowDate").equals(""))?" is null ":"=")+getString("nowDate")+"  ");
		sql.append("AND ");
		sql.append("A.AC_END_DT >"+((getString("nowDate").equals(""))?" is null ":"=")+getString("nowDate")+" ");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		SelectResultRset srr = db.executeQuery();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return srr;
	}

	public SelectResultRset SELECT_PMDLNO01(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("SELECT ");
		sql.append("NVL(MDLNO      ,'') AS MDLNO      ,");
		sql.append("NVL(SUP_CD     ,'') AS SUP_CD     ,");
		sql.append("NVL(MFC_CD     ,'') AS MFC_CD     ,");
		sql.append("NVL(SLS_DEPT_CD,'') AS SLS_DEPT_CD,");
		sql.append("NVL(CLR_CD     ,'') AS CLR_CD     ,");
		sql.append("NVL(BRND_CD    ,'') AS BRND_CD    ,");
		sql.append("NVL(O_MDLNO    ,'') AS O_MDLNO    ,");
		sql.append("NVL(HS_CD      ,'') AS HS_CD      ,");
		sql.append("NVL(ACC_CAT    ,'') AS ACC_CAT    ,");
		sql.append("NVL(OVS_CAT    ,'') AS OVS_CAT    ,");
		sql.append("NVL(AVD_ID     ,'') AS AVD_ID     ,");
		sql.append("NVL(R_QTY_ID   ,'') AS R_QTY_ID   ,");
		sql.append("NVL(M_ACC_QTY  ,'') AS M_ACC_QTY  ,");
		sql.append("NVL(DEC_P      ,'') AS DEC_P      ,");
		sql.append("NVL(UNIT_CD    ,'') AS UNIT_CD    ,");
		sql.append("NVL(IND_MDLNO  ,'') AS IND_MDLNO  ,");
		sql.append("NVL(KIT_ID     ,'') AS KIT_ID     ,");
		sql.append("NVL(CCM_ID     ,'') AS CCM_ID     ,");
		sql.append("NVL(CMDY_NM    ,'') AS CMDY_NM    ,");
		sql.append("NVL(DEPT       ,'') AS DEPT       ,");
		sql.append("NVL(NM         ,'') AS NM         ,");
		sql.append("NVL(PTNR_CD    ,'') AS PTNR_CD ");
		sql.append("FROM ");
		sql.append("PMDLNO ");
		sql.append("WHERE ");
		sql.append("MDLNO "+((getString("IMDLNO").equals(""))?" is null ":"=")+getString("IMDLNO")+" ");
		sql.append("AND ");
		sql.append("SUP_CD "+((getString("SUP_CD").equals(""))?" is null ":"=")+getString("SUP_CD")+"");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		SelectResultRset srr = db.executeQuery();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return srr;
	}

	public SelectResultRset SELECT_INTIC0202(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("SELECT ");
		sql.append("NVL(ITM_NO,        '') AS ITM_NO,");
		sql.append("NVL(APL_BDT,       '') AS APL_BDT,");
		sql.append("NVL(APL_EDT,       '') AS APL_EDT,");
		sql.append("NVL(GNR_ADM_NO,    '') AS GNR_ADM_NO,");
		sql.append("NVL(SCSN_ITM_NO,   '') AS SCSN_ITM_NO,");
		sql.append("NVL(QTY_NSUM_TYP,  '') AS QTY_NSUM_TYP,");
		sql.append("NVL(CSLD_ITM_NO,   '') AS CSLD_ITM_NO,");
		sql.append("NVL(RGS_DTTM,      '') AS RGS_DTTM,");
		sql.append("NVL(RGS_USR_CD,    '') AS RGS_USR_CD,");
		sql.append("NVL(UPD_DTTM,      '') AS UPD_DTTM,");
		sql.append("NVL(UPD_USR_CD,    '') AS UPD_USR_CD,");
		sql.append("NVL(LC_RGS_DTTM,   '') AS LC_RGS_DTTM,");
		sql.append("NVL(LCL_UPD_DTTM,  '') AS LCL_UPD_DTTM,");
		sql.append("NVL(FNL_UPD_PGM_ID,'') AS FNL_UPD_PGM_ID,");
		sql.append("NVL(DEL_TYP,   	'') AS DEL_TYP ");
		sql.append("FROM ");
		sql.append("INTIC ");
		sql.append("WHERE ");
		sql.append("ITM_NO	"+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+" ");
		sql.append("AND ");
		sql.append("APL_BDT	<"+((getString("NOW").equals(""))?" is null ":"=")+getString("NOW")+" ");
		sql.append("AND ");
		sql.append("APL_EDT >"+((getString("NOW").equals(""))?" is null ":"=")+getString("NOW")+" ");
		sql.append("ORDER BY GNR_ADM_NO DESC");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		SelectResultRset srr = db.executeQuery();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return srr;
	}

	public int INSERT_BM0204(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("INSERT INTO BM02(");
		sql.append("SEQ_NO ,");
		sql.append("ITM_NO ,");
		sql.append("ODR_DVSN_CD ,");
		sql.append("APL_BDT ,");
		sql.append("APL_EDT ,");
		sql.append("GNR_ADM_NO ,");
		sql.append("TMP_AC_TYP ,");
		sql.append("SCSN_ITM_NO ,");
		sql.append("QTY_NSUM_TYP ,");
		sql.append("CSLD_ITM_NO ,");
		sql.append("CTRL_DVSN_CD ,");
		sql.append("MFCC_CD ,");
		sql.append("PRNT_DVSN_CD ,");
		sql.append("DSP_SPCF_CTNT ,");
		sql.append("IBO_CAT_CD ,");
		sql.append("FMCC_DPT_NM ,");
		sql.append("FMCC_CHRG_NM ,");
		sql.append("PRV_ITM_NO ,");
		sql.append("CLR_CD ,");
		sql.append("BRND_CD ,");
		sql.append("HS_CD ,");
		sql.append("ACC_CAT_CD ,");
		sql.append("SLS_QTY_UN_CD ,");
		sql.append("SLC_PRMT_ITM_TYP ,");
		sql.append("ITM_NM_ENG ,");
		sql.append("KIT_TYP ,");
		sql.append("GFT_TYP ,");
		sql.append("FOC_TYP ,");
		sql.append("MIN_ODR_QTY ,");
		sql.append("STD_PKG_SZ ,");
		sql.append("STD_PKG_WDTH ,");
		sql.append("STD_PKG_HI ,");
		sql.append("STD_PKG_WGT ,");
		sql.append("TMP_PRIZ_TYP ,");
		sql.append("STD_UP ,");
		sql.append("ITM_NM_CN ,");
		sql.append("SLS_ROUT_TYP ,");
		sql.append("ITM_NET_WGT	,");
		sql.append("FM_TYP ,");
		sql.append("RGS_DTTM ,");
		sql.append("RGS_CHRG_CD ,");
		sql.append("RGS_PGID ,");
		sql.append("UPD_DTTM ,");
		sql.append("UPD_CHRG_CD ,");
		sql.append("UPD_PGID");
		sql.append(") ");
		sql.append("SELECT SEQ_BM02.NEXTVAL,");
		sql.append("ITM_NO ,");
		sql.append("ODR_DVSN_CD ,");
		sql.append("APL_BDT ,");
		sql.append("APL_EDT ,");
		sql.append("GNR_ADM_NO ,");
		sql.append("TMP_AC_TYP ,");
		sql.append("SCSN_ITM_NO ,");
		sql.append("QTY_NSUM_TYP ,");
		sql.append("CSLD_ITM_NO ,");
		sql.append("CTRL_DVSN_CD ,");
		sql.append("MFCC_CD ,");
		sql.append("PRNT_DVSN_CD ,");
		sql.append("DSP_SPCF_CTNT ,");
		sql.append("IBO_CAT_CD ,");
		sql.append("FMCC_DPT_NM ,");
		sql.append("FMCC_CHRG_NM ,");
		sql.append("PRV_ITM_NO ,");
		sql.append("CLR_CD ,");
		sql.append("BRND_CD ,");
		sql.append("HS_CD ,");
		sql.append("ACC_CAT_CD ,");
		sql.append("SLS_QTY_UN_CD ,");
		sql.append("SLC_PRMT_ITM_TYP ,");
		sql.append("ITM_NM_ENG ,");
		sql.append("KIT_TYP ,");
		sql.append("GFT_TYP ,");
		sql.append("FOC_TYP ,");
		sql.append("MIN_ODR_QTY ,");
		sql.append("STD_PKG_SZ ,");
		sql.append("STD_PKG_WDTH ,");
		sql.append("STD_PKG_HI ,");
		sql.append("STD_PKG_WGT ,");
		sql.append("TMP_PRIZ_TYP ,");
		sql.append("STD_UP ,");
		sql.append("ITM_NM_CN ,");
		sql.append("SLS_ROUT_TYP ,");
		sql.append("ITM_NET_WGT	,");
		sql.append("FM_TYP ,");
		sql.append("RGS_DTTM ,");
		sql.append("RGS_CHRG_CD ,");
		sql.append("RGS_PGID ,");
		sql.append("UPD_DTTM ,");
		sql.append("UPD_CHRG_CD ,");
		sql.append("UPD_PGID ");
		sql.append("FROM M02 ");
		sql.append("WHERE ");
		sql.append("ITM_NO			"+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+" ");
		sql.append("AND                     ");
		sql.append("ODR_DVSN_CD		"+((getString("ODR_DVSN_CD").equals(""))?" is null ":"=")+getString("ODR_DVSN_CD")+" ");
		sql.append("AND                     ");
		sql.append("FM_TYP			"+((getString("FM_TYP").equals(""))?" is null ":"=")+getString("FM_TYP")+" ");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		int updateCount = db.executeUpdate();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return updateCount;
	}

	public SelectResultRset SELECT_PPRCO01(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("SELECT ");
		sql.append("NVL(PER_PACK ,    '') AS PER_PACK ,");
		sql.append("NVL(AVBL_DT1 ,    '') AS AVBL_DT1 ,");
		sql.append("NVL(VALD_DT1 ,    '') AS VALD_DT1 ,");
		sql.append("NVL(UNIT_P1 ,    '') AS UNIT_P1 ,");
		sql.append("NVL(UNIT_P2 ,    '') AS UNIT_P2 ,");
		sql.append("NVL(U_P_DEC_PNT1 ,    '') AS U_P_DEC_PNT1 ,");
		sql.append("NVL(U_P_DEC_PNT2 ,    '') AS U_P_DEC_PNT2 ,");
		sql.append("NVL(TO_CHAR(MIN_ACC_QTY) ,    ' ') AS MIN_ACC_QTY ,");
		sql.append("NVL(DEPTH ,    '') AS DEPTH ,");
		sql.append("NVL(WIDTH ,'') AS WIDTH ,");
		sql.append("NVL(HEIGHT ,       '') AS HEIGHT ,");
		sql.append("NVL(GRS_WT ,       '') AS DCAT_CD ,");
		sql.append("NVL(NET_WT ,    '') AS NET_WT ");
		sql.append("FROM PPRC ");
		sql.append("WHERE  ");
		sql.append("MDLNO "+((getString("MDLNO").equals(""))?" is null ":"=")+getString("MDLNO")+" ");
		sql.append("AND ");
		sql.append("SUP_CD "+((getString("SUP_CD").equals(""))?" is null ":"=")+getString("SUP_CD")+"");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		SelectResultRset srr = db.executeQuery();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return srr;
	}

	public SelectResultRset SELECT_PPRC_PRICE(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("SELECT (CASE WHEN ((t.avbl_dt1<to_number(to_char(sysdate,'YYYYMMDD'))) and");
		sql.append("                   (t.vald_dt1>to_number(to_char(sysdate,'YYYYMMDD')))) THEN (t.unit_p1*(POWER(0.1,t.u_p_dec_pnt1))) ");
		sql.append("             WHEN ((t.avbl_dt2<to_number(to_char(sysdate,'YYYYMMDD'))) and");
		sql.append("                   (t.vald_dt2>to_number(to_char(sysdate,'YYYYMMDD')))) THEN (t.unit_p2*(POWER(0.1,t.u_p_dec_pnt2))) ");
		sql.append("             WHEN ((NVL(t.avbl_dt2,0)=0) and");
		sql.append("                   (t.avbl_dt1>to_number(to_char(sysdate,'YYYYMMDD')))) THEN (t.unit_p1*(POWER(0.1,t.u_p_dec_pnt1)))   ");
		sql.append("             WHEN ((NVL(t.avbl_dt2,0)=0) and");
		sql.append("                   (t.vald_dt1<to_number(to_char(sysdate,'YYYYMMDD')))) THEN (t.unit_p1*(POWER(0.1,t.u_p_dec_pnt1)))   ");
		sql.append("             WHEN ((t.vald_dt1<t.vald_dt2) and");
		sql.append("                   (t.vald_dt2<to_number(to_char(sysdate,'YYYYMMDD')))) THEN (t.unit_p2*(POWER(0.1,t.u_p_dec_pnt2)))  ");
		sql.append("ELSE 0 END) as PRICE ,t.*");
		sql.append("from PPRC t ");
		sql.append("WHERE  ");
		sql.append("MDLNO "+((getString("MDLNO").equals(""))?" is null ":"=")+getString("MDLNO")+" ");
		sql.append("AND ");
		sql.append("SUP_CD "+((getString("SUP_CD").equals(""))?" is null ":"=")+getString("SUP_CD")+"");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		SelectResultRset srr = db.executeQuery();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return srr;
	}

	public SelectResultRset SELECT_M0101(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append(" SELECT ");
		sql.append(" TRPT_NM_CN AS TRPT_NM_CN");
		sql.append(" FROM ");
		sql.append(" M01");
		sql.append(" WHERE");
		sql.append(" VDR_CD =	"+getString("VDR_CD")+"");
		sql.append(" AND");
		sql.append(" APL_BDT <"+((getString("APL_BDT").equals(""))?" is null ":"=")+getString("APL_BDT")+"");
		sql.append(" AND ");
		sql.append(" FM_TYP<>"+getString("FM_TYP_6")+"");
		sql.append(" AND ");
		sql.append(" FM_TYP<>"+getString("FM_TYP_9")+"");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		SelectResultRset srr = db.executeQuery();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return srr;
	}


	public void setITM_NO(String value){
		if(value==null) {
			paramsString.remove("ITM_NO");
			return;
		}
		paramsString.put("ITM_NO",value);
	}


	public void setODR_DVSN_CD(String value){
		if(value==null) {
			paramsString.remove("ODR_DVSN_CD");
			return;
		}
		paramsString.put("ODR_DVSN_CD",value);
	}


	public void setAPL_BDT(String value){
		if(value==null) {
			paramsString.remove("APL_BDT");
			return;
		}
		paramsString.put("APL_BDT",value);
	}


	public void setAPL_EDT(String value){
		if(value==null) {
			paramsString.remove("APL_EDT");
			return;
		}
		paramsString.put("APL_EDT",value);
	}


	public void setGNR_ADM_NO(String value){
		if(value==null) {
			paramsString.remove("GNR_ADM_NO");
			return;
		}
		paramsString.put("GNR_ADM_NO",value);
	}


	public void setTMP_AC_TYP(String value){
		if(value==null) {
			paramsString.remove("TMP_AC_TYP");
			return;
		}
		paramsString.put("TMP_AC_TYP",value);
	}


	public void setSCSN_ITM_NO(String value){
		if(value==null) {
			paramsString.remove("SCSN_ITM_NO");
			return;
		}
		paramsString.put("SCSN_ITM_NO",value);
	}


	public void setQTY_NSUM_TYP(String value){
		if(value==null) {
			paramsString.remove("QTY_NSUM_TYP");
			return;
		}
		paramsString.put("QTY_NSUM_TYP",value);
	}


	public void setCSLD_ITM_NO(String value){
		if(value==null) {
			paramsString.remove("CSLD_ITM_NO");
			return;
		}
		paramsString.put("CSLD_ITM_NO",value);
	}


	public void setCTRL_DVSN_CD(String value){
		if(value==null) {
			paramsString.remove("CTRL_DVSN_CD");
			return;
		}
		paramsString.put("CTRL_DVSN_CD",value);
	}


	public void setMFCC_CD(String value){
		if(value==null) {
			paramsString.remove("MFCC_CD");
			return;
		}
		paramsString.put("MFCC_CD",value);
	}


	public void setPRNT_DVSN_CD(String value){
		if(value==null) {
			paramsString.remove("PRNT_DVSN_CD");
			return;
		}
		paramsString.put("PRNT_DVSN_CD",value);
	}


	public void setDSP_SPCF_CTNT(String value){
		if(value==null) {
			paramsString.remove("DSP_SPCF_CTNT");
			return;
		}
		paramsString.put("DSP_SPCF_CTNT",value);
	}


	public void setIBO_CAT_CD(String value){
		if(value==null) {
			paramsString.remove("IBO_CAT_CD");
			return;
		}
		paramsString.put("IBO_CAT_CD",value);
	}


	public void setFMCC_DPT_NM(String value){
		if(value==null) {
			paramsString.remove("FMCC_DPT_NM");
			return;
		}
		paramsString.put("FMCC_DPT_NM",value);
	}


	public void setFMCC_CHRG_NM(String value){
		if(value==null) {
			paramsString.remove("FMCC_CHRG_NM");
			return;
		}
		paramsString.put("FMCC_CHRG_NM",value);
	}


	public void setPRV_ITM_NO(String value){
		if(value==null) {
			paramsString.remove("PRV_ITM_NO");
			return;
		}
		paramsString.put("PRV_ITM_NO",value);
	}


	public void setCLR_CD(String value){
		if(value==null) {
			paramsString.remove("CLR_CD");
			return;
		}
		paramsString.put("CLR_CD",value);
	}


	public void setBRND_CD(String value){
		if(value==null) {
			paramsString.remove("BRND_CD");
			return;
		}
		paramsString.put("BRND_CD",value);
	}


	public void setHS_CD(String value){
		if(value==null) {
			paramsString.remove("HS_CD");
			return;
		}
		paramsString.put("HS_CD",value);
	}


	public void setACC_CAT_CD(String value){
		if(value==null) {
			paramsString.remove("ACC_CAT_CD");
			return;
		}
		paramsString.put("ACC_CAT_CD",value);
	}


	public void setITM_NM_ENG(String value){
		if(value==null) {
			paramsString.remove("ITM_NM_ENG");
			return;
		}
		paramsString.put("ITM_NM_ENG",value);
	}


	public void setSLS_QTY_UN_CD(String value){
		if(value==null) {
			paramsString.remove("SLS_QTY_UN_CD");
			return;
		}
		paramsString.put("SLS_QTY_UN_CD",value);
	}


	public void setSLC_PRMT_ITM_TYP(String value){
		if(value==null) {
			paramsString.remove("SLC_PRMT_ITM_TYP");
			return;
		}
		paramsString.put("SLC_PRMT_ITM_TYP",value);
	}


	public void setKIT_TYP(String value){
		if(value==null) {
			paramsString.remove("KIT_TYP");
			return;
		}
		paramsString.put("KIT_TYP",value);
	}


	public void setGFT_TYP(String value){
		if(value==null) {
			paramsString.remove("GFT_TYP");
			return;
		}
		paramsString.put("GFT_TYP",value);
	}


	public void setFOC_TYP(String value){
		if(value==null) {
			paramsString.remove("FOC_TYP");
			return;
		}
		paramsString.put("FOC_TYP",value);
	}


	public void setMIN_ODR_QTY(String value){
		if(value==null) {
			paramsString.remove("MIN_ODR_QTY");
			return;
		}
		paramsString.put("MIN_ODR_QTY",value);
	}


	public void setSTD_PKG_SZ(String value){
		if(value==null) {
			paramsString.remove("STD_PKG_SZ");
			return;
		}
		paramsString.put("STD_PKG_SZ",value);
	}


	public void setSTD_PKG_WDTH(String value){
		if(value==null) {
			paramsString.remove("STD_PKG_WDTH");
			return;
		}
		paramsString.put("STD_PKG_WDTH",value);
	}


	public void setSTD_PKG_HI(String value){
		if(value==null) {
			paramsString.remove("STD_PKG_HI");
			return;
		}
		paramsString.put("STD_PKG_HI",value);
	}


	public void setSTD_PKG_WGT(String value){
		if(value==null) {
			paramsString.remove("STD_PKG_WGT");
			return;
		}
		paramsString.put("STD_PKG_WGT",value);
	}


	public void setTMP_PRIZ_TYP(String value){
		if(value==null) {
			paramsString.remove("TMP_PRIZ_TYP");
			return;
		}
		paramsString.put("TMP_PRIZ_TYP",value);
	}


	public void setSTD_UP(String value){
		if(value==null) {
			paramsString.remove("STD_UP");
			return;
		}
		paramsString.put("STD_UP",value);
	}


	public void setITM_NM_CN(String value){
		if(value==null) {
			paramsString.remove("ITM_NM_CN");
			return;
		}
		paramsString.put("ITM_NM_CN",value);
	}


	public void setSLS_ROUT_TYP(String value){
		if(value==null) {
			paramsString.remove("SLS_ROUT_TYP");
			return;
		}
		paramsString.put("SLS_ROUT_TYP",value);
	}


	public void setITM_NET_WGT(String value){
		if(value==null) {
			paramsString.remove("ITM_NET_WGT");
			return;
		}
		paramsString.put("ITM_NET_WGT",value);
	}


	public void setRGS_DTTM(String value){
		if(value==null) {
			paramsString.remove("RGS_DTTM");
			return;
		}
		paramsString.put("RGS_DTTM",value);
	}


	public void setRGS_CHRG_CD(String value){
		if(value==null) {
			paramsString.remove("RGS_CHRG_CD");
			return;
		}
		paramsString.put("RGS_CHRG_CD",value);
	}


	public void setRGS_PGID(String value){
		if(value==null) {
			paramsString.remove("RGS_PGID");
			return;
		}
		paramsString.put("RGS_PGID",value);
	}


	public void setUPD_DTTM(String value){
		if(value==null) {
			paramsString.remove("UPD_DTTM");
			return;
		}
		paramsString.put("UPD_DTTM",value);
	}


	public void setUPD_CHRG_CD(String value){
		if(value==null) {
			paramsString.remove("UPD_CHRG_CD");
			return;
		}
		paramsString.put("UPD_CHRG_CD",value);
	}


	public void setUPD_PGID(String value){
		if(value==null) {
			paramsString.remove("UPD_PGID");
			return;
		}
		paramsString.put("UPD_PGID",value);
	}


	public void setFM_TYP(String value){
		if(value==null) {
			paramsString.remove("FM_TYP");
			return;
		}
		paramsString.put("FM_TYP",value);
	}


	public void setVDR_CD(String value){
		if(value==null) {
			paramsString.remove("VDR_CD");
			return;
		}
		paramsString.put("VDR_CD",value);
	}


	public void setFM_TYP1(String value){
		if(value==null) {
			paramsString.remove("FM_TYP1");
			return;
		}
		paramsString.put("FM_TYP1",value);
	}


	public void setFM_TYP2(String value){
		if(value==null) {
			paramsString.remove("FM_TYP2");
			return;
		}
		paramsString.put("FM_TYP2",value);
	}


	public void setUNI_ITM_NO(String value){
		if(value==null) {
			paramsString.remove("UNI_ITM_NO");
			return;
		}
		paramsString.put("UNI_ITM_NO",value);
	}


	public void setnowDate(String value){
		if(value==null) {
			paramsString.remove("nowDate");
			return;
		}
		paramsString.put("nowDate",value);
	}


	public void setIMDLNO(String value){
		if(value==null) {
			paramsString.remove("IMDLNO");
			return;
		}
		paramsString.put("IMDLNO",value);
	}


	public void setSUP_CD(String value){
		if(value==null) {
			paramsString.remove("SUP_CD");
			return;
		}
		paramsString.put("SUP_CD",value);
	}


	public void setNOW(String value){
		if(value==null) {
			paramsString.remove("NOW");
			return;
		}
		paramsString.put("NOW",value);
	}


	public void setMDLNO(String value){
		if(value==null) {
			paramsString.remove("MDLNO");
			return;
		}
		paramsString.put("MDLNO",value);
	}


	public void setFM_TYP_6(String value){
		if(value==null) {
			paramsString.remove("FM_TYP_6");
			return;
		}
		paramsString.put("FM_TYP_6",value);
	}


	public void setFM_TYP_9(String value){
		if(value==null) {
			paramsString.remove("FM_TYP_9");
			return;
		}
		paramsString.put("FM_TYP_9",value);
	}


}
